SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_GetEventLogConfig
	@ID int
AS
SELECT c.*, t.LogTypeFriendlyName
FROM dbo.DnnProduct_EventLogConfig AS c
	INNER JOIN dbo.DnnProduct_EventLogTypes AS t ON t.LogTypeKey = c.LogTypeKey
WHERE (ID = @ID or @ID IS NULL)
ORDER BY t.LogTypeFriendlyName ASC

GO
